pre_ip = "https://apimarket-test" \
         ".shinho.net.cn"

api_test_env = pre_ip

sys_code = "18120049"
password = "Shinho123"
platform = "F"
username = "郑慧民"

# 仪表盘 YTD全部

paramsYTD1 = {"chats_name": "Sell-in 业绩 - YTD", "username": username, "pra_index": ["YTD3", "YTD15", "YTD20", "YTD1"],
              "pra_groupby": ["Y"], "pra_timespan": ["201912"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["CTP-GT", "D-GT", "D-GT&MT", "D-GT&R", "WS-GT"],
              "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "253", "type": 1, "pra_geoc_prov": ["120"],
              "pra_prd_categ1": ["020"], "userid": sys_code}

paramsYTD2 = {"chats_name": "Sell-in 业绩 - YTD", "username": username, "pra_index": ["YTD3", "YTD15", "YTD20", "YTD1"],
              "pra_groupby": ["Y"], "pra_timespan": ["202001"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["CTP-餐饮终端", "D-R&GT", "D-R&MT", "D-餐批", "D-餐饮", "WS-R"],
              "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "253", "type": 1, "pra_geoc_prov": ["020"],
              "pra_prd_categ1": ["010"], "userid": sys_code}

paramsYTD3 = {"chats_name": "Sell-in 业绩 - YTD", "username": username, "pra_index": ["YTD3", "YTD15", "YTD20", "YTD1"],
              "pra_groupby": ["Y"], "pra_timespan": ["202003"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["D-MT", "D-MT&GT", "D-MT&R"], "pra_prd_unified_idx": [],
              "pra_prd_sku": [], "chats_id": "253", "type": 1, "pra_geoc_prov": ["150"], "pra_prd_categ1": ["070"],
              "userid": sys_code}

paramsYTD4 = {"chats_name": "Sell-in 业绩 - YTD", "username": username, "pra_index": ["YTD3", "YTD15", "YTD20", "YTD1"],
              "pra_groupby": ["Y"], "pra_timespan": ["202005"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["直营KA"], "pra_prd_unified_idx": [], "pra_prd_sku": [],
              "chats_id": "253", "type": 1,
              "pra_geoc_prov": ["130", "020", "060", "110", "070", "180", "100", "010", "030"],
              "pra_prd_categ1": ["050"], "userid": sys_code}

paramsYTD5 = {"chats_name": "Sell-in 业绩 - YTD", "username": username, "pra_index": ["YTD3", "YTD15", "YTD20", "YTD1"],
              "pra_groupby": ["Y"], "pra_timespan": ["202006"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "253",
              "type": 1, "pra_geoc_city": ["City000064"], "pra_prd_categ1": ["060"], "userid": sys_code}

paramsYTD6 = {"chats_name": "Sell-in 业绩 - YTD", "username": username,
              "pra_index": ["YTD3", "YTD15", "YTD20", "YTD1"],
              "pra_groupby": ["Y"], "pra_timespan": ["202007"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [],
              "chats_id": "253",
              "type": 1, "userid": sys_code}
# QTD全部

paramsQTD1 = {"chats_name": "Sell-in 业绩 - QTD", "username": username, "pra_index": ["QTD3", "QTD15", "QTD20", "QTD1"],
              "pra_groupby": ["Q"], "pra_timespan": ["201912"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["CTP-GT", "D-GT", "D-GT&MT", "D-GT&R", "WS-GT"],
              "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "252", "type": 1, "pra_geoc_prov": ["120"],
              "pra_prd_categ1": ["020"], "userid": sys_code}

paramsQTD2 = {"chats_name": "Sell-in 业绩 - QTD", "username": username, "pra_index": ["QTD3", "QTD15", "QTD20", "QTD1"],
              "pra_groupby": ["Q"], "pra_timespan": ["202001"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["CTP-餐饮终端", "D-R&GT", "D-R&MT", "D-餐批", "D-餐饮", "WS-R"],
              "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "252", "type": 1, "pra_geoc_prov": ["020"],
              "pra_prd_categ1": ["010"], "userid": sys_code}

paramsQTD3 = {"chats_name": "Sell-in 业绩 - QTD", "username": username, "pra_index": ["QTD3", "QTD15", "QTD20", "QTD1"],
              "pra_groupby": ["Q"], "pra_timespan": ["202003"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["D-MT", "D-MT&GT", "D-MT&R"], "pra_prd_unified_idx": [],
              "pra_prd_sku": [], "chats_id": "252", "type": 1, "pra_geoc_prov": ["150"], "pra_prd_categ1": ["070"],
              "userid": sys_code}

paramsQTD4 = {"chats_name": "Sell-in 业绩 - QTD", "username": username, "pra_index": ["QTD3", "QTD15", "QTD20", "QTD1"],
              "pra_groupby": ["Q"], "pra_timespan": ["202005"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["直营KA"], "pra_prd_unified_idx": [], "pra_prd_sku": [],
              "chats_id": "252", "type": 1,
              "pra_geoc_prov": ["130", "020", "060", "110", "070", "180", "100", "010", "030"],
              "pra_prd_categ1": ["050"], "userid": sys_code}

paramsQTD5 = {"chats_name": "Sell-in 业绩 - QTD", "username": username, "pra_index": ["QTD3", "QTD15", "QTD20", "QTD1"],
              "pra_groupby": ["Q"], "pra_timespan": ["202006"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "252",
              "type": 1, "pra_geoc_city": ["City000064"], "pra_prd_categ1": ["060"], "userid": sys_code}

paramsQTD6 = {"chats_name": "Sell-in 业绩 - QTD", "username": username, "pra_index": ["QTD3", "QTD15", "QTD20", "QTD1"],
              "pra_groupby": ["Q"], "pra_timespan": ["202007"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "252",
              "type": 1, "userid": sys_code}

# MTD全部

paramsMTD1 = {"group_code":"0012","chats_group_name":"业绩表现","chats_name":"Sell-in 业绩 - MTD","username":username,
              "pra_index":["MTD3","MTD15","MTD20","MTD1"],"pra_groupby":["M"],"pra_timespan":["202103"],
              "pra_org_lob":["00100249"],"pra_geoc_prov":[],"pra_geoc_city":[],"pra_geoc_county":[],"pra_prd_categ1":[],
              "pra_brand":[],"pra_dealer_chl":[],"pra_cust_cd":[],"pra_prd_unified_idx":[],"pra_prd_sku":[],
              "chats_id":"251","type":1,"userid":sys_code}

paramsMTD2 = {"chats_name": "Sell-in 业绩 - MTD", "username": username, "pra_index": ["MTD3", "MTD15", "MTD20", "MTD1"],
              "pra_groupby": ["M"], "pra_timespan": ["202001"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["CTP-餐饮终端", "D-R&GT", "D-R&MT", "D-餐批", "D-餐饮", "WS-R"],
              "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "251", "type": 1, "pra_geoc_prov": ["020"],
              "pra_prd_categ1": ["010"], "userid": sys_code}

paramsMTD3 = {"chats_name": "Sell-in 业绩 - MTD", "username": username, "pra_index": ["MTD3", "MTD15", "MTD20", "MTD1"],
              "pra_groupby": ["M"], "pra_timespan": ["202003"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["D-MT", "D-MT&GT", "D-MT&R"], "pra_prd_unified_idx": [],
              "pra_prd_sku": [], "chats_id": "251", "type": 1, "pra_geoc_prov": ["150"], "pra_prd_categ1": ["070"],
              "userid": sys_code}

paramsMTD4 = {"chats_name": "Sell-in 业绩 - MTD", "username": username, "pra_index": ["MTD3", "MTD15", "MTD20", "MTD1"],
              "pra_groupby": ["M"], "pra_timespan": ["202005"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": ["直营KA"], "pra_prd_unified_idx": [], "pra_prd_sku": [],
              "chats_id": "251", "type": 1,
              "pra_geoc_prov": ["130", "020", "060", "110", "070", "180", "100", "010", "030"],
              "pra_prd_categ1": ["050"], "userid": sys_code}

paramsMTD5 = {"chats_name": "Sell-in 业绩 - MTD", "username": username, "pra_index": ["MTD3", "MTD15", "MTD20", "MTD1"],
              "pra_groupby": ["M"], "pra_timespan": ["202006"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [], "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "251",
              "type": 1, "pra_geoc_city": ["City000064"], "pra_prd_categ1": ["060"], "userid": sys_code}

paramsMTD6 = {"chats_name": "Sell-in 业绩 - MTD", "username": username, "pra_index": ["MTD3", "MTD15", "MTD20", "MTD1"],
              "pra_groupby": ["M"], "pra_timespan": ["202007"], "pra_org_lob": ["00100249"], "pra_brand": [],
              "pra_channel": [],
              "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "251", "type": 1,
              "userid": sys_code}
# MTD趋势

paramsMTD_DailyTrend1 = {"chats_name": "Sell-in 业绩 - MTD 日趋势", "username": username,
                         "pra_index": ["MRL3", "MRL7", "MRL8", "MRL10", "MRL11", "MRL13", "MRL14", "MRL1"],
                         "pra_groupby": ["M"], "pra_timespan": ["201912"], "pra_org_lob": ["00100249"], "pra_brand": [],
                         "pra_channel": [], "pra_dealer_chl": ["CTP-GT", "D-GT", "D-GT&MT", "D-GT&R", "WS-GT"],
                         "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "250", "type": 1,
                         "pra_geoc_prov": ["120"], "pra_prd_categ1": ["020"], "userid": sys_code}


paramsMTD_DailyTrend2 = {"chats_name": "Sell-in 业绩 - MTD 日趋势", "username": username,
                         "pra_index": ["MRL3", "MRL7", "MRL8", "MRL10", "MRL11", "MRL13", "MRL14", "MRL1"],
                         "pra_groupby": ["M"], "pra_timespan": ["202001"], "pra_org_lob": ["00100249"], "pra_brand": [],
                         "pra_channel": [], "pra_dealer_chl": ["CTP-餐饮终端", "D-R&GT", "D-R&MT", "D-餐批", "D-餐饮", "WS-R"],
                         "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "250", "type": 1,
                         "pra_geoc_city": ["City000077"], "pra_prd_categ1": ["010"], "userid": sys_code}

paramsMTD_DailyTrend3 = {"chats_name": "Sell-in 业绩 - MTD 日趋势", "username": username,
                         "pra_index": ["MRL3", "MRL7", "MRL8", "MRL10", "MRL11", "MRL13", "MRL14", "MRL1"],
                         "pra_groupby": ["M"], "pra_timespan": ["202003"], "pra_org_lob": ["00100249"], "pra_brand": [],
                         "pra_channel": [], "pra_dealer_chl": ["D-MT", "D-MT&GT", "D-MT&R"], "pra_prd_unified_idx": [],
                         "pra_prd_sku": [], "chats_id": "250", "type": 1, "pra_geoc_prov": ["150"],
                         "pra_prd_categ1": ["070"], "userid": sys_code}

paramsMTD_DailyTrend4 = {"chats_name": "Sell-in 业绩 - MTD 日趋势", "username": username,
                         "pra_index": ["MRL3", "MRL7", "MRL8", "MRL10", "MRL11", "MRL13", "MRL14", "MRL1"],
                         "pra_groupby": ["M"], "pra_timespan": ["202005"], "pra_org_lob": ["00100249"], "pra_brand": [],
                         "pra_channel": [], "pra_dealer_chl": ["直营KA"], "pra_prd_unified_idx": [], "pra_prd_sku": [],
                         "chats_id": "250", "type": 1,
                         "pra_geoc_prov": ["130", "020", "060", "110", "070", "180", "100", "010", "030"],
                         "pra_prd_categ1": ["050"], "userid": sys_code}

paramsMTD_DailyTrend5 = {"chats_name": "Sell-in 业绩 - MTD 日趋势", "username": username,
                         "pra_index": ["MRL3", "MRL7", "MRL8", "MRL10", "MRL11", "MRL13", "MRL14", "MRL1"],
                         "pra_groupby": ["M"], "pra_timespan": ["202006"], "pra_org_lob": ["00100249"], "pra_brand": [],
                         "pra_channel": [], "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [],
                         "chats_id": "250", "type": 1, "pra_geoc_city": ["City000064"], "pra_prd_categ1": ["060"],
                         "userid": sys_code}


paramsMTD_DailyTrend6 = {"chats_name": "Sell-in 业绩 - MTD 日趋势", "username": username,
                         "pra_index": ["MRL3", "MRL7", "MRL8", "MRL10", "MRL11", "MRL13", "MRL14", "MRL1"],
                         "pra_groupby": ["M"],
                         "pra_timespan": ["202007"], "pra_org_lob": ["00100249"], "pra_brand": [], "pra_channel": [],
                         "pra_dealer_chl": [], "pra_prd_unified_idx": [], "pra_prd_sku": [], "chats_id": "250",
                         "type": 1,
                         "userid": sys_code}

# 业绩检视
performanceReview1 = {"card_param_fin_dto_list": [{"pra_timespan": ["201901", "201902", "201903", "201904", "201905",
                                                                    "201906", "201907", "201908", "201909", "201910",
                                                                    "201911", "201912"], "code_display": "1",
                                                   "order_type": "1", "page_index": 1, "page_size": 10,
                                                   "pra_groupby": ["M", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"],
                                                   "pra_geoc_prov": ["120"], "pra_geoc_city": [], "pra_geoc_county": [],
                                                   "pra_prd_categ1": ["020"], "pra_prd_categ2": [],
                                                   "pra_prd_categ3": [], "pra_prd_categ4": [], "pra_prd_categ5": [],
                                                   "pra_cust_top": [], "pra_cust_pra": [], "pra_cntct_cust": [],
                                                   "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [],
                                                   "pra_dealer_chl": ["D-GT", "D-GT&R", "D-GT&MT", "WS-GT"],
                                                   "pra_prd_sku": [], "pra_prd_unified_idx": [], "type": 1,
                                                   "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]}],
                      "flag": "0", "pageable": 1, "year_check_summary_fin_dto_list": [
        {"pra_timespan": ["201912"], "code_display": "1", "order_type": "1", "page_index": 1, "page_size": 10,
         "pra_groupby": ["Y", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"], "pra_geoc_prov": ["120"],
         "pra_geoc_city": [], "pra_geoc_county": [], "pra_prd_categ1": ["020"], "pra_prd_categ2": [],
         "pra_prd_categ3": [], "pra_prd_categ4": [], "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [],
         "pra_cntct_cust": [], "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [],
         "pra_dealer_chl": ["D-GT", "D-GT&R", "D-GT&MT", "WS-GT"], "pra_prd_sku": [], "pra_prd_unified_idx": [],
         "type": 1, "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]}], "userid": sys_code}

performanceReview2 = {"card_param_fin_dto_list": [{"pra_timespan": ["202001", "202002", "202003", "202004", "202005",
                                                                    "202006", "202007", "202008", "202009", "202010",
                                                                    "202011", "202012"], "code_display": "1",
                                                   "order_type": "1", "page_index": 1, "page_size": 10,
                                                   "pra_groupby": ["M", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"],
                                                   "pra_geoc_prov": ["020"], "pra_geoc_city": [], "pra_geoc_county": [],
                                                   "pra_prd_categ1": ["010"], "pra_prd_categ2": [],
                                                   "pra_prd_categ3": [], "pra_prd_categ4": [], "pra_prd_categ5": [],
                                                   "pra_cust_top": [], "pra_cust_pra": [], "pra_cntct_cust": [],
                                                   "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [],
                                                   "pra_dealer_chl": ["D-餐饮", "D-餐批", "D-R&GT", "D-R&MT", "WS-R"],
                                                   "pra_prd_sku": [], "pra_prd_unified_idx": [], "type": 1,
                                                   "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]}],
                      "flag": "0", "pageable": 1, "year_check_summary_fin_dto_list": [
        {"pra_timespan": ["202012"], "code_display": "1", "order_type": "1", "page_index": 1, "page_size": 10,
         "pra_groupby": ["Y", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"], "pra_geoc_prov": ["020"],
         "pra_geoc_city": [], "pra_geoc_county": [], "pra_prd_categ1": ["010"], "pra_prd_categ2": [],
         "pra_prd_categ3": [], "pra_prd_categ4": [], "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [],
         "pra_cntct_cust": [], "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [],
         "pra_dealer_chl": ["D-餐饮", "D-餐批", "D-R&GT", "D-R&MT", "WS-R"], "pra_prd_sku": [], "pra_prd_unified_idx": [],
         "type": 1, "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]}], "userid": sys_code}

performanceReview3 = {"card_param_fin_dto_list": [{"pra_timespan": ["202001", "202002", "202003", "202004", "202005",
                                                                    "202006", "202007", "202008", "202009", "202010",
                                                                    "202011", "202012"], "code_display": "1",
                                                   "order_type": "1", "page_index": 1, "page_size": 10,
                                                   "pra_groupby": ["M", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"],
                                                   "pra_geoc_prov": ["150"], "pra_geoc_city": [], "pra_geoc_county": [],
                                                   "pra_prd_categ1": ["070"], "pra_prd_categ2": [],
                                                   "pra_prd_categ3": [], "pra_prd_categ4": [], "pra_prd_categ5": [],
                                                   "pra_cust_top": [], "pra_cust_pra": [], "pra_cntct_cust": [],
                                                   "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [],
                                                   "pra_dealer_chl": ["D-MT", "D-MT&GT", "D-MT&R"], "pra_prd_sku": [],
                                                   "pra_prd_unified_idx": [], "type": 1,
                                                   "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]}],
                      "flag": "0", "pageable": 1, "year_check_summary_fin_dto_list": [
        {"pra_timespan": ["202012"], "code_display": "1", "order_type": "1", "page_index": 1, "page_size": 10,
         "pra_groupby": ["Y", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"], "pra_geoc_prov": ["150"],
         "pra_geoc_city": [], "pra_geoc_county": [], "pra_prd_categ1": ["070"], "pra_prd_categ2": [],
         "pra_prd_categ3": [], "pra_prd_categ4": [], "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [],
         "pra_cntct_cust": [], "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [],
         "pra_dealer_chl": ["D-MT", "D-MT&GT", "D-MT&R"], "pra_prd_sku": [], "pra_prd_unified_idx": [], "type": 1,
         "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]}], "userid": sys_code}

performanceReview4 = {"card_param_fin_dto_list": [{"pra_timespan": ["202001", "202002", "202003", "202004", "202005",
                                                                    "202006", "202007", "202008", "202009", "202010",
                                                                    "202011", "202012"], "code_display": "1",
                                                   "order_type": "1", "page_index": 1, "page_size": 10,
                                                   "pra_groupby": ["M", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"],
                                                   "pra_geoc_prov": ["130", "020", "110", "060", "070", "030", "010",
                                                                     "180", "100"], "pra_geoc_city": [],
                                                   "pra_geoc_county": [], "pra_prd_categ1": ["050"],
                                                   "pra_prd_categ2": [], "pra_prd_categ3": [], "pra_prd_categ4": [],
                                                   "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [],
                                                   "pra_cntct_cust": [], "pra_cust_cd": [], "pra_cust_type": [],
                                                   "pra_brand": [], "pra_dealer_chl": ["直营KA"], "pra_prd_sku": [],
                                                   "pra_prd_unified_idx": [], "type": 1,
                                                   "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]}],
                      "flag": "0", "pageable": 1, "year_check_summary_fin_dto_list": [
        {"pra_timespan": ["202012"], "code_display": "1", "order_type": "1", "page_index": 1, "page_size": 10,
         "pra_groupby": ["Y", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"],
         "pra_geoc_prov": ["130", "020", "110", "060", "070", "030", "010", "180", "100"], "pra_geoc_city": [],
         "pra_geoc_county": [], "pra_prd_categ1": ["050"], "pra_prd_categ2": [], "pra_prd_categ3": [],
         "pra_prd_categ4": [], "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [], "pra_cntct_cust": [],
         "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [], "pra_dealer_chl": ["直营KA"], "pra_prd_sku": [],
         "pra_prd_unified_idx": [], "type": 1, "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]}],
                      "userid": sys_code}

performanceReview5 = {"card_param_fin_dto_list": [{"pra_timespan": ["202001", "202002", "202003", "202004", "202005",
                                                                    "202006", "202007", "202008", "202009", "202010",
                                                                    "202011", "202012"], "code_display": "1",
                                                   "order_type": "1", "page_index": 1, "page_size": 10,
                                                   "pra_groupby": ["M", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"],
                                                   "pra_geoc_prov": [], "pra_geoc_city": ["City000064"],
                                                   "pra_geoc_county": [], "pra_prd_categ1": ["060"],
                                                   "pra_prd_categ2": [], "pra_prd_categ3": [], "pra_prd_categ4": [],
                                                   "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [],
                                                   "pra_cntct_cust": [], "pra_cust_cd": [], "pra_cust_type": [],
                                                   "pra_brand": [], "pra_dealer_chl": [], "pra_prd_sku": [],
                                                   "pra_prd_unified_idx": [], "type": 1,
                                                   "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]}],
                      "flag": "0", "pageable": 1, "year_check_summary_fin_dto_list": [
        {"pra_timespan": ["202012"], "code_display": "1", "order_type": "1", "page_index": 1, "page_size": 10,
         "pra_groupby": ["Y", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"], "pra_geoc_prov": [],
         "pra_geoc_city": ["City000064"], "pra_geoc_county": [], "pra_prd_categ1": ["060"], "pra_prd_categ2": [],
         "pra_prd_categ3": [], "pra_prd_categ4": [], "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [],
         "pra_cntct_cust": [], "pra_cust_cd": [], "pra_cust_type": [], "pra_brand": [], "pra_dealer_chl": [],
         "pra_prd_sku": [], "pra_prd_unified_idx": [], "type": 1,
         "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]}], "userid": sys_code}

performanceReview6 = {"card_param_fin_dto_list": [{"pra_timespan": ["202001", "202002", "202003", "202004", "202005",
                                                                    "202006", "202007", "202008", "202009", "202010",
                                                                    "202011", "202012"], "code_display": "1",
                                                   "order_type": "1", "page_index": 1, "page_size": 10,
                                                   "pra_groupby": ["M", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"],
                                                   "pra_geoc_prov": [], "pra_geoc_city": [], "pra_geoc_county": [],
                                                   "pra_prd_categ1": [], "pra_prd_categ2": [], "pra_prd_categ3": [],
                                                   "pra_prd_categ4": [], "pra_prd_categ5": [], "pra_cust_top": [],
                                                   "pra_cust_pra": [], "pra_cntct_cust": [], "pra_cust_cd": [],
                                                   "pra_cust_type": [], "pra_brand": [], "pra_dealer_chl": [],
                                                   "pra_prd_sku": [], "pra_prd_unified_idx": [], "type": 1,
                                                   "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]}],
                      "flag": "0", "pageable": 1, "year_check_summary_fin_dto_list": [
        {"pra_timespan": ["202012"], "code_display": "1", "order_type": "1", "page_index": 1, "page_size": 10,
         "pra_groupby": ["Y", "PRA_ORG_LOB"], "pra_org_lob": ["00100249"], "pra_geoc_prov": [], "pra_geoc_city": [],
         "pra_geoc_county": [], "pra_prd_categ1": [], "pra_prd_categ2": [], "pra_prd_categ3": [], "pra_prd_categ4": [],
         "pra_prd_categ5": [], "pra_cust_top": [], "pra_cust_pra": [], "pra_cntct_cust": [], "pra_cust_cd": [],
         "pra_cust_type": [], "pra_brand": [], "pra_dealer_chl": [], "pra_prd_sku": [], "pra_prd_unified_idx": [],
         "type": 1, "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]}], "userid": sys_code}

# 高阶切分
# AdvancedSegmentation1 =


AdvancedSegmentation4 = {
    "pra_index": ["MTD1", "MTD16", "MTD17", "MTD4", "MTD6", "MTD9", "MTD7", "YTM13", "YTM14", "YTM4", "YTM6", "YTM7",
                  "MTD", "YTM"], "pra_groupby": ["M", "PRA_CUST_CD"], "group_code": "0012",
    "pra_cust_type": ["TOP Parent", "Parent", "4"], "type": "2", "page_index": 1, "page_size": 2000,
    "pra_geoc_prov": ["130", "020", "110", "060", "070", "030", "010", "180", "100"], "pra_geoc_city": [],
    "pra_geoc_county": [], "pra_prd_categ1": ["050"], "pra_prd_categ2": [], "pra_prd_categ3": [], "pra_prd_categ4": [],
    "pra_prd_categ5": [], "pra_brand": [], "pra_prd_unified_idx": [], "pra_cust_cd": [], "pra_prd_sku": [],
    "pra_timespan": ["202005"], "username": username, "chats_group_name": "业绩表现", "index_id": "MTD4", "order_type": "1",
    "pra_dealer_chl": ["直营KA"], "pra_org_lob": ["00100249"], "userid": sys_code}


pra_brand_1 = {
            "code_display": "1",
            "pra_cust_type": ["2"],
            "cust_group_type": "3",
            "pra_org_ct": ["01002070"],
            "pra_cust_cd": ["0031000718"],
            "pra_groupby": ["M"],
            "pra_timespan": ["202001"],
            "userid": "17120059"
        }

pra_brand_2 = {
            "code_display": "1",
            "pra_cust_type": ["2"],
            "cust_group_type": "3",
            "pra_org_ct": ["01002070"],
            "pra_cust_cd": ["0031000718"],
            "pra_groupby": ["Q"],
            "pra_timespan": ["202001"],
            "userid": "17120059"
        }

pra_brand_3 = {
            "code_display": "1",
            "pra_cust_type": ["2"],
            "cust_group_type": "3",
            "pra_org_ct": ["01002070"],
            "pra_cust_cd": ["0031000718"],
            "pra_groupby": ["Y"],
            "pra_timespan": ["202001"],
            "userid": "17120059"
        }

pra_categ_dashboard_1 = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 2000,
            "pra_groupby": ["M", "PRA_PRD_CATEG1"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": ["020", "010", "070", "050", "060", "999999"],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["MTD9", "MTD2", "MTD20", "MTD3", "MTD1"]
        }],
        "flag": "0",
        "userid": "17120059"
    }

pra_categ_dashboard_2 = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 2000,
            "pra_groupby": ["M", "PRA_PRD_CATEG1"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": ["020", "010", "070", "050", "060", "999999"],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["QTD9", "QTD2", "QTD20", "QTD3", "QTD1"]
        }],
        "flag": "0",
        "userid": "17120059"
    }

pra_categ_dashboard_3 = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 2000,
            "pra_groupby": ["M", "PRA_PRD_CATEG1"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": ["020", "010", "070", "050", "060", "999999"],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["YTD9", "YTD2", "YTD20", "YTD3", "YTD1"]
        }],
        "flag": "0",
        "userid": "17120059"
    }

pra_brand_dashboard_1 = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 2000,
            "pra_groupby": ["M", "PRA_BRAND"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": ["020", "010", "070", "050", "060", "999999"],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["MTD9", "MTD2", "MTD20", "MTD3", "MTD1"]
        }],
        "flag": "0",
        "userid": "17120059"
    }

pra_brand_dashboard_2 = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 2000,
            "pra_groupby": ["M", "PRA_BRAND"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": ["020", "010", "070", "050", "060", "999999"],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["QTD9", "QTD2", "QTD20", "QTD3", "QTD1"]
        }],
        "flag": "0",
        "userid": "17120059"
    }

pra_brand_dashboard_3 = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 2000,
            "pra_groupby": ["M", "PRA_BRAND"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": ["020", "010", "070", "050", "060", "999999"],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["YTD9", "YTD2", "YTD20", "YTD3", "YTD1"]
        }],
        "flag": "0",
        "userid": "17120059"
    }

all_check_brand = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001", "202002", "202003", "202004", "202005", "202006", "202007", "202008", "202009", "202010", "202011", "202012"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 10,
            "pra_groupby": ["M", "PRA_BRAND"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": [],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]
        }],
        "flag": "0",
        "pageable": 1,
        "year_check_summary_fin_dto_list": [{
            "pra_timespan": ["202012"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 10,
            "pra_groupby": ["Y", "PRA_BRAND"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": [],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]
        }],
        "userid": "17120059"
    }

all_check_categ = {
        "card_param_fin_dto_list": [{
            "pra_timespan": ["202001", "202002", "202003", "202004", "202005", "202006", "202007", "202008", "202009", "202010", "202011", "202012"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 10,
            "pra_groupby": ["M", "PRA_PRD_CATEG1"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": [],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["MTD1", "MTH12", "MTH13", "MTH3", "MTH5"]
        }],
        "flag": "0",
        "pageable": 1,
        "year_check_summary_fin_dto_list": [{
            "pra_timespan": ["202012"],
            "code_display": "1",
            "order_type": "1",
            "page_index": 1,
            "page_size": 10,
            "pra_groupby": ["Y", "PRA_PRD_CATEG1"],
            "pra_org_lob": ["00100249"],
            "pra_geoc_prov": [],
            "pra_geoc_city": [],
            "pra_geoc_county": [],
            "pra_prd_categ1": [],
            "pra_prd_categ2": [],
            "pra_prd_categ3": [],
            "pra_prd_categ4": [],
            "pra_prd_categ5": [],
            "pra_cust_top": [],
            "pra_cust_pra": [],
            "pra_cntct_cust": [],
            "pra_cust_cd": ["0031000718"],
            "pra_cust_type": ["2"],
            "pra_brand": [],
            "pra_dealer_chl": [],
            "pra_prd_sku": [],
            "pra_prd_unified_idx": [],
            "type": 1,
            "pra_index": ["YTD1", "YTD28", "YTD24", "YTD11", "YTD26"]
        }],
        "userid": "17120059"
    }


